﻿CREATE TABLE [dbo].[User]
(
    [UserID]               INT IDENTITY (1000, 1) NOT NULL,
    [UserName]             NVARCHAR (50)          NOT NULL,
    [Email]                NVARCHAR (100)         NULL,
    [EmailConfirmed]       BIT                    NOT NULL,
    [PasswordHash]         NVARCHAR (100)         NULL,
    [SecurityStamp]        NVARCHAR (100)         NULL,
    [PhoneNumber]          NVARCHAR (25)          NULL,
    [PhoneNumberConfirmed] BIT                    NOT NULL,
    [TwoFactorEnabled]     BIT                    NOT NULL,
    [LockoutEndDateUtc]    DATETIME               NULL,
    [LockoutEnabled]       BIT                    NOT NULL,
    [AccessFailedCount]    INT                    NOT NULL,

    CONSTRAINT [PK_User_UserID] PRIMARY KEY CLUSTERED ([UserID] ASC),
    CONSTRAINT [UK_User_UserName] UNIQUE NONCLUSTERED ([UserName] ASC)
);
